package com.sumec.dao;


import com.sumec.entity.WorkSignSummary;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface WorkSignSummaryMapper {
    int deleteByPrimaryKey(Long id);

    int insert(WorkSignSummary record);

    int insertSelective(WorkSignSummary record);

    WorkSignSummary selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(WorkSignSummary record);

    int updateByPrimaryKey(WorkSignSummary record);

    List<WorkSignSummary> listByWorkCode(String workCode);

    String findEarliestSignInTime(String workCode);

    String findLatestSignOutTime(String workCode);

    String findEarliestSignInDate(@Param("workCode") String workCode, @Param("earliestsignInTime") String earliestsignInTime);

    String findLatestSignOutDate(@Param("workCode") String workCode, @Param("latestsignOutTime") String latestsignOutTime);
}